/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50715
 Source Host           : localhost:3306
 Source Schema         : guli_0401

 Target Server Type    : MySQL
 Target Server Version : 50715
 File Encoding         : 65001

 Date: 12/06/2020 19:43:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for edu_chapter
-- ----------------------------
DROP TABLE IF EXISTS `edu_chapter`;
CREATE TABLE `edu_chapter` (
  `id` char(19) NOT NULL COMMENT '章节ID',
  `course_id` char(19) NOT NULL COMMENT '课程ID',
  `title` varchar(50) NOT NULL COMMENT '章节名称',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '显示排序',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_course_id` (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程';

-- ----------------------------
-- Records of edu_chapter
-- ----------------------------
BEGIN;
INSERT INTO `edu_chapter` VALUES ('1', '14', '第一章：HTML', 1, '2019-01-01 12:27:40', '2019-01-01 12:55:30');
INSERT INTO `edu_chapter` VALUES ('1267008312792457217', '1267008165723381761', '第一章：HTML超文本标记语言', 1, '2020-05-31 16:21:36', '2020-05-31 16:21:36');
INSERT INTO `edu_chapter` VALUES ('1267011193088122881', '1266559701021540354', '第一章：HTML-test', 1, '2020-05-31 16:33:03', '2020-05-31 16:33:03');
INSERT INTO `edu_chapter` VALUES ('1267011959517487106', '1266559701021540354', '第二章：CSS-test', 2, '2020-05-31 16:36:06', '2020-05-31 16:36:06');
INSERT INTO `edu_chapter` VALUES ('15', '18', '第一章：Java入门', 1, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('3', '14', '第二章：CSS', 2, '2019-01-01 12:55:35', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('32', '18', '第二章：控制台输入和输出', 2, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('44', '18', '第三章：控制流', 3, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('48', '18', '第四章：类的定义', 4, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('63', '18', '第五章：数组', 5, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('64', '18', '第六章：继承', 6, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('65', '18', '第七章：多态性和抽象类', 7, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
COMMIT;

-- ----------------------------
-- Table structure for edu_course
-- ----------------------------
DROP TABLE IF EXISTS `edu_course`;
CREATE TABLE `edu_course` (
  `id` char(19) NOT NULL COMMENT '课程ID',
  `teacher_id` char(19) DEFAULT NULL COMMENT '课程讲师ID',
  `subject_id` char(19) DEFAULT NULL COMMENT '课程专业ID',
  `subject_parent_id` char(19) DEFAULT NULL,
  `title` varchar(50) NOT NULL COMMENT '课程标题',
  `price` decimal(10,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '课程销售价格，设置为0则可免费观看',
  `lesson_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '总课时',
  `cover` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '课程封面图片路径',
  `buy_count` bigint(10) unsigned DEFAULT '0' COMMENT '销售数量',
  `view_count` bigint(10) unsigned DEFAULT '0' COMMENT '浏览数量',
  `version` bigint(20) unsigned DEFAULT '1' COMMENT '乐观锁',
  `status` varchar(10) NOT NULL DEFAULT 'Draft' COMMENT '视频状态 Draft未发布  Normal已发布',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_title` (`title`),
  KEY `idx_subject_id` (`subject_id`),
  KEY `idx_teacher_id` (`teacher_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程';

-- ----------------------------
-- Records of edu_course
-- ----------------------------
BEGIN;
INSERT INTO `edu_course` VALUES ('10', '1', '221', NULL, '零基础入门学习Python课程学习', 1.0000, 10, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/cover/bizhi.gif', 80, 165, 21, 'Normal', '2018-03-26 00:00:28', '2020-06-01 08:05:30');
INSERT INTO `edu_course` VALUES ('1266317252634267649', '10', '1266167422129692674', NULL, '测试updateVo', 11.0000, 10, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/cover/bizhi.gif', 0, 0, 1, 'Draft', '2020-05-29 18:35:35', '2020-05-29 19:09:29');
INSERT INTO `edu_course` VALUES ('1266539974807183361', '1265776235560538114', '1266167422079361026', NULL, 'tttttsss', 10.0000, 10, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/cover/bizhi.gif', 0, 0, 1, 'Draft', '2020-05-30 09:20:36', '2020-05-30 09:20:36');
INSERT INTO `edu_course` VALUES ('1266559701021540354', '1098970098250674178', '1266167422331019266', NULL, 'php', 10.0000, 10, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/cover/bizhi.gif', 0, 0, 1, 'Draft', '2020-05-30 10:38:59', '2020-05-30 10:38:59');
INSERT INTO `edu_course` VALUES ('1266648766488174594', '1098970098250674178', '1266167422079361026', NULL, '测试大纲', 10.0000, 10, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/cover/bizhi.gif', 0, 0, 1, 'Draft', '2020-05-30 16:32:54', '2020-05-30 16:32:54');
INSERT INTO `edu_course` VALUES ('1266650835299278850', '1265583638376251393', '1266167422079361026', NULL, 'assss', 10.0000, 10, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/cover/bizhi.gif', 0, 0, 1, 'Draft', '2020-05-30 16:41:07', '2020-05-30 16:41:07');
INSERT INTO `edu_course` VALUES ('1266653216246296578', '12', '1266167422079361026', NULL, 'dadadada', 1.0000, 10, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/cover/bizhi.gif', 0, 0, 1, 'Draft', '2020-05-30 16:50:35', '2020-05-30 16:50:35');
INSERT INTO `edu_course` VALUES ('1266677018569138177', '12', '1266167422079361026', NULL, 'wwwzzz', 10.0000, 10, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/cover/bizhi.gif', 0, 0, 1, 'Draft', '2020-05-30 18:25:10', '2020-05-30 18:25:10');
INSERT INTO `edu_course` VALUES ('14', '1', '221', NULL, 'XHTML CSS2 JS整站制作教程课程学习', 0.0000, 3, '', 3, 29, 15, 'Draft', '2018-04-02 18:33:34', '2019-02-21 20:46:36');
INSERT INTO `edu_course` VALUES ('15', '1', '251', NULL, 'HTML5入门课程学习', 0.0000, 23, '', 0, 39, 17, 'Draft', '2018-04-02 18:34:32', '2019-02-21 20:46:37');
INSERT INTO `edu_course` VALUES ('17', '2', '223', NULL, 'MySql从入门到精通', 0.0000, 100, '', 34, 130, 4, 'Draft', '2018-04-02 21:13:58', '2019-02-21 20:46:38');
INSERT INTO `edu_course` VALUES ('18', '2', '202', NULL, 'Java精品课程', 0.0000, 20, '', 150, 522, 6, 'Draft', '2018-04-02 21:28:46', '2019-02-21 20:46:39');
INSERT INTO `edu_course` VALUES ('21', '3', '221', NULL, '搜索引擎优化技术', 0.0000, 23, '', 23, 123, 1, 'Draft', '2018-09-15 11:38:57', '2019-02-21 20:46:40');
INSERT INTO `edu_course` VALUES ('22', '3', '223', NULL, '影响力摄影小课堂', 0.0000, 0, '', 0, 2, 3, 'Draft', '2018-11-02 10:49:41', '2019-02-21 20:46:40');
INSERT INTO `edu_course` VALUES ('24', '3', '223', NULL, '国家教师资格考试', 0.0000, 12, '', 324, 25, 3, 'Draft', '2018-11-04 09:48:44', '2019-02-21 20:46:41');
INSERT INTO `edu_course` VALUES ('25', '3', '223', NULL, '听力口语训练营', 0.0000, 0, '', 0, 13, 14, 'Draft', '2018-02-26 19:23:48', '2019-02-21 20:46:42');
INSERT INTO `edu_course` VALUES ('26', '4', '223', NULL, 'CAD4零基础教学', 0.0000, 0, '', 0, 34, 35, 'Draft', '2018-02-26 19:24:44', '2019-02-21 20:46:43');
COMMIT;

-- ----------------------------
-- Table structure for edu_course_description
-- ----------------------------
DROP TABLE IF EXISTS `edu_course_description`;
CREATE TABLE `edu_course_description` (
  `id` char(19) NOT NULL COMMENT '课程ID',
  `description` text COMMENT '课程简介',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程简介';

-- ----------------------------
-- Records of edu_course_description
-- ----------------------------
BEGIN;
INSERT INTO `edu_course_description` VALUES ('1266262674609950721', '', '2020-05-29 14:58:42', '2020-05-29 14:58:42');
INSERT INTO `edu_course_description` VALUES ('1266264101734469633', '', '2020-05-29 15:04:23', '2020-05-29 15:04:23');
INSERT INTO `edu_course_description` VALUES ('1266307696004878337', '<p>阿斯顿撒的</p>', '2020-05-29 17:57:36', '2020-05-29 17:57:36');
INSERT INTO `edu_course_description` VALUES ('1266317252634267649', '<p>Java很好</p>\n<p>大数据很好</p>', '2020-05-29 18:35:35', '2020-05-29 19:09:29');
INSERT INTO `edu_course_description` VALUES ('1266539974807183361', '<p>12</p>', '2020-05-30 09:20:36', '2020-05-30 09:20:36');
INSERT INTO `edu_course_description` VALUES ('1266559701021540354', '<p>sadasdasdasd</p>', '2020-05-30 10:38:59', '2020-05-30 10:38:59');
INSERT INTO `edu_course_description` VALUES ('1266648766488174594', '<p>12</p>', '2020-05-30 16:32:54', '2020-05-30 16:32:54');
INSERT INTO `edu_course_description` VALUES ('1266650835299278850', '<p>11</p>', '2020-05-30 16:41:07', '2020-05-30 16:41:07');
INSERT INTO `edu_course_description` VALUES ('1266653216246296578', '<p>1221</p>', '2020-05-30 16:50:35', '2020-05-30 16:50:35');
INSERT INTO `edu_course_description` VALUES ('1266677018569138177', '<p>1</p>', '2020-05-30 18:25:10', '2020-05-30 18:25:10');
COMMIT;

-- ----------------------------
-- Table structure for edu_subject
-- ----------------------------
DROP TABLE IF EXISTS `edu_subject`;
CREATE TABLE `edu_subject` (
  `id` char(19) NOT NULL COMMENT '课程类别ID',
  `title` varchar(10) NOT NULL COMMENT '类别名称',
  `parent_id` char(19) NOT NULL DEFAULT '0' COMMENT '父ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程科目';

-- ----------------------------
-- Records of edu_subject
-- ----------------------------
BEGIN;
INSERT INTO `edu_subject` VALUES ('1266167422041612290', '前端开发', '0', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422079361026', 'html', '1266167422041612290', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422129692674', 'css', '1266167422041612290', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422180024322', 'vue', '1266167422041612290', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422251327490', '后端开发', '0', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422284881921', 'java', '1266167422251327490', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422331019266', 'php', '1266167422251327490', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422402322434', '数据库', '0', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422431682561', 'mysql', '1266167422402322434', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422477819905', 'redis', '1266167422402322434', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422507180034', '大数据', '0', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
INSERT INTO `edu_subject` VALUES ('1266167422528151553', 'hadoop', '1266167422507180034', 0, '2020-05-29 08:40:12', '2020-05-29 08:40:12');
COMMIT;

-- ----------------------------
-- Table structure for edu_teacher
-- ----------------------------
DROP TABLE IF EXISTS `edu_teacher`;
CREATE TABLE `edu_teacher` (
  `id` char(19) NOT NULL COMMENT '讲师ID',
  `name` varchar(20) NOT NULL COMMENT '讲师姓名',
  `intro` varchar(255) NOT NULL COMMENT '讲师资历,一句话说明讲师',
  `career` text COMMENT '讲师简介',
  `level` int(10) unsigned NOT NULL COMMENT '头衔 1高级讲师 2首席讲师',
  `avatar` varchar(255) DEFAULT NULL COMMENT '讲师头像',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='讲师';

-- ----------------------------
-- Records of edu_teacher
-- ----------------------------
BEGIN;
INSERT INTO `edu_teacher` VALUES ('10', '唐嫣', '北京师范大学法学院副教授', '北京师范大学法学院副教授、清华大学法学博士。自2004年至今已有9年的司法考试培训经验。长期从事司法考试辅导，深知命题规律，了解解题技巧。内容把握准确，授课重点明确，层次分明，调理清晰，将法条法理与案例有机融合，强调综合，深入浅出。', 1, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 20, 0, '2018-04-03 14:32:19', '2019-02-22 02:01:26');
INSERT INTO `edu_teacher` VALUES ('1098969411110432769', 'string name', 'string intros', 'string career', 2, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 10, 0, '2019-02-22 23:35:00', '2020-05-28 06:56:54');
INSERT INTO `edu_teacher` VALUES ('1098970098250674178', '刘德华1', 'string intro', 'string career', 2, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 10, 0, '2019-02-22 23:37:44', '2019-02-22 23:38:30');
INSERT INTO `edu_teacher` VALUES ('11', '11', '11', NULL, 1, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 0, 0, '2019-02-21 21:09:55', '2019-02-22 02:01:25');
INSERT INTO `edu_teacher` VALUES ('12', 'string11', 'string11', 'string11', 1, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 0, 0, '2020-05-27 10:12:41', '2020-05-27 10:16:09');
INSERT INTO `edu_teacher` VALUES ('1265583638376251393', '测试0401', '妞妞', '很好狠批', 1, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 2, 0, '2020-05-27 18:00:27', '2020-05-27 18:00:27');
INSERT INTO `edu_teacher` VALUES ('1265776235560538114', 'test007', 'sadsadfddfdf', 'sadsad', 1, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 22, 0, '2020-05-28 06:45:46', '2020-05-28 06:45:46');
INSERT INTO `edu_teacher` VALUES ('1265886032104415234', '测试909090', '测试', '测试', 1, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 1, 0, '2020-05-28 14:02:04', '2020-05-28 14:02:04');
INSERT INTO `edu_teacher` VALUES ('1265893481934905346', 'test525252', 'asdasdsad', 'sdasafdsf', 1, 'https://edu-wenqinzheng.oss-cn-hangzhou.aliyuncs.com/avatar/2020/05/28/a0588d21-f0e8-4824-a13b-c93d71890a28.jpg', 1, 0, '2020-05-28 14:31:40', '2020-05-28 14:31:40');
INSERT INTO `edu_teacher` VALUES ('3', '钟汉良', '毕业于北京大学数学系', '中教一级职称。讲课极具亲和力。', 1, '', 1, 0, '2018-03-31 09:20:46', '2019-02-22 02:01:27');
INSERT INTO `edu_teacher` VALUES ('4', '周杰伦', '长期从事考研政治课讲授和考研命题趋势与应试对策研究。考研辅导新锐派的代表。', '政治学博士、管理学博士后，北京师范大学马克思主义学院副教授。多年来总结出了一套行之有效的应试技巧与答题方法，针对性和实用性极强，能帮助考生在轻松中应考，在激励的竞争中取得高分，脱颖而出。', 1, '', 1, 0, '2018-04-03 14:13:51', '2019-02-22 02:01:28');
INSERT INTO `edu_teacher` VALUES ('5', '陈伟霆', '人大附中2009届毕业生', '北京大学数学科学学院2008级本科生，2012年第八届学生五四奖章获得者，在数学领域取得多项国际国内奖项，学术研究成绩突出。曾被两次评为北京大学三好学生、一次评为北京大学三好标兵，获得过北京大学国家奖学金、北京大学廖凯原奖学金、北京大学星光国际一等奖学金、北京大学明德新生奖学金等。', 1, '', 1, 0, '2018-04-03 14:15:36', '2019-02-22 02:01:29');
INSERT INTO `edu_teacher` VALUES ('6', '姚晨', '华东师范大学数学系硕士生导师，中国数学奥林匹克高级教练', '曾参与北京市及全国多项数学活动的命题和组织工作，多次带领北京队参加高中、初中、小学的各项数学竞赛，均取得优异成绩。教学活而新，能够调动学生的学习兴趣并擅长对学生进行思维点拨，对学生学习习惯的养成和非智力因素培养有独到之处，是一位深受学生喜爱的老师。', 1, '', 1, 0, '2018-04-01 14:19:28', '2019-02-22 02:01:29');
INSERT INTO `edu_teacher` VALUES ('7', '胡歌', '考研政治辅导实战派专家，全国考研政治命题研究组核心成员。', '法学博士，北京师范大学马克思主义学院副教授，专攻毛泽东思想概论、邓小平理论，长期从事考研辅导。出版著作两部，发表学术论文30余篇，主持国家社会科学基金项目和教育部重大课题子课题各一项，参与中央实施马克思主义理论研究和建设工程项目。', 2, '', 8, 0, '2018-04-03 14:21:03', '2019-02-22 02:01:30');
INSERT INTO `edu_teacher` VALUES ('8', '旦增尼玛', '上海师范大学法学院副教授', '上海师范大学法学院副教授、清华大学法学博士。自2004年至今已有9年的司法考试培训经验。长期从事司法考试辅导，深知命题规律，了解解题技巧。内容把握准确，授课重点明确，层次分明，调理清晰，将法条法理与案例有机融合，强调综合，深入浅出。', 1, '', 9, 0, '2018-04-03 14:23:06', '2019-02-22 02:01:31');
INSERT INTO `edu_teacher` VALUES ('9', '谢娜', '资深课程设计专家，专注10年AACTP美国培训协会认证导师', '十年课程研发和培训咨询经验，曾任国企人力资源经理、大型外企培训经理，负责企业大学和培训体系搭建；曾任专业培训机构高级顾问、研发部总监，为包括广东移动、东莞移动、深圳移动、南方电网、工商银行、农业银行、民生银行、邮储银行、TCL集团、清华大学继续教育学院、中天路桥、广西扬翔股份等超过200家企业提供过培训与咨询服务，并担任近50个大型项目的总负责人。', 1, '', 10, 0, '2018-04-03 14:23:33', '2019-02-22 02:01:32');
COMMIT;

-- ----------------------------
-- Table structure for edu_video
-- ----------------------------
DROP TABLE IF EXISTS `edu_video`;
CREATE TABLE `edu_video` (
  `id` char(19) NOT NULL COMMENT '视频ID',
  `course_id` char(19) NOT NULL COMMENT '课程ID',
  `chapter_id` char(19) NOT NULL COMMENT '章节ID',
  `title` varchar(50) NOT NULL COMMENT '节点名称',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
  `play_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '播放次数',
  `is_free` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否可以试听：0免费 1收费',
  `video_source_id` varchar(100) DEFAULT NULL COMMENT '视频资源',
  `video_original_name` varchar(100) DEFAULT NULL COMMENT '视频源文件名称',
  `duration` float NOT NULL DEFAULT '0' COMMENT '视频时长（秒）',
  `status` varchar(20) NOT NULL DEFAULT '' COMMENT '视频状态:见阿里云文档',
  `size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '视频源文件大小（字节）',
  `version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_course_id` (`course_id`),
  KEY `idx_chapter_id` (`chapter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='课程视频';

-- ----------------------------
-- Records of edu_video
-- ----------------------------
BEGIN;
INSERT INTO `edu_video` VALUES ('1266978946465984513', '', '', '第五节: 测试', 5, 0, 1, '', NULL, 0, '', 0, 1, '2020-05-31 14:24:55', '2020-05-31 14:24:55');
INSERT INTO `edu_video` VALUES ('1266979149394800641', '', '', '第五节：测试11', 5, 0, 1, '', NULL, 0, '', 0, 1, '2020-05-31 14:25:43', '2020-05-31 14:25:43');
INSERT INTO `edu_video` VALUES ('1266979979393036290', '', '15', '第五节：测试测试', 5, 0, 1, '', NULL, 0, '', 0, 1, '2020-05-31 14:29:01', '2020-05-31 14:29:01');
INSERT INTO `edu_video` VALUES ('1267008423920541697', '', '1267008312792457217', '第一节：h1标题', 1, 0, 1, '', NULL, 0, '', 0, 1, '2020-05-31 16:22:03', '2020-05-31 16:22:03');
INSERT INTO `edu_video` VALUES ('1267011712124854274', '', '1267011193088122881', '第一节：test1', 1, 0, 1, '16cf0fc9c8524919970e8e3d44411c7b', NULL, 0, 'Normal', 0, 1, '2020-05-31 16:35:07', '2020-06-02 15:15:19');
INSERT INTO `edu_video` VALUES ('1267011775685337090', '1267011121675902977', '1267011193088122881', '第二节：test22', 2, 0, 1, '16cf0fc9c8524919970e8e3d44411c7b', NULL, 0, 'Normal', 0, 1, '2020-05-31 16:35:22', '2020-05-31 16:35:22');
INSERT INTO `edu_video` VALUES ('1267012040115232770', '1267011121675902977', '1267011959517487106', '第五节：css样式', 5, 0, 1, '16cf0fc9c8524919970e8e3d44411c7b', '123.mp4', 0, 'Normal', 0, 1, '2020-05-31 16:36:25', '2020-06-03 08:05:32');
INSERT INTO `edu_video` VALUES ('1267012146268872706', '1267011121675902977', '1267011959517487106', '第二节：backgroud-color', 2, 0, 1, '', NULL, 0, '', 0, 1, '2020-05-31 16:36:50', '2020-05-31 16:37:03');
INSERT INTO `edu_video` VALUES ('1267959198926741505', '', '1267011193088122881', '第三节：link标签', 3, 0, 1, '5029a3828f1c4b248a87b80b8c1aba8e', NULL, 0, '', 0, 1, '2020-06-03 07:20:05', '2020-06-03 07:20:05');
INSERT INTO `edu_video` VALUES ('1267964158280105986', '', '1267011959517487106', '第三节：css枫叶', 3, 0, 1, '93d9bebbcb23430ea7f66da223cc7dd7', '123.mp4', 0, '', 0, 1, '2020-06-03 07:39:48', '2020-06-03 07:39:48');
INSERT INTO `edu_video` VALUES ('1267966474345414658', '', '1267011959517487106', '第四节：form', 4, 0, 1, '7b5b9de3c86346d6a7c45e2f6dc52d48', '123.mp4', 0, '', 0, 1, '2020-06-03 07:49:00', '2020-06-03 07:49:00');
INSERT INTO `edu_video` VALUES ('17', '18', '15', '第一节：Java简介', 1, 1000, 1, '', NULL, 100, 'Draft', 0, 1, '2019-01-01 13:08:57', '2019-02-21 20:46:08');
INSERT INTO `edu_video` VALUES ('18', '18', '15', '第二节：表达式和赋值语句', 2, 999, 1, '', NULL, 100, 'Draft', 0, 1, '2019-01-01 13:09:02', '2019-02-21 20:46:09');
INSERT INTO `edu_video` VALUES ('19', '18', '15', '第三节：String类', 3, 888, 0, '', NULL, 100, 'Draft', 0, 1, '2019-01-01 13:09:05', '2019-02-21 20:46:10');
INSERT INTO `edu_video` VALUES ('20', '18', '15', '第四节：程序风格', 4, 666, 0, '', NULL, 100, 'Draft', 0, 1, '2019-01-01 13:09:05', '2019-02-21 20:46:10');
COMMIT;

-- ----------------------------
-- Table structure for statistics_daily
-- ----------------------------
DROP TABLE IF EXISTS `statistics_daily`;
CREATE TABLE `statistics_daily` (
  `id` char(19) NOT NULL COMMENT '主键',
  `date_calculated` varchar(20) NOT NULL COMMENT '统计日期',
  `register_num` int(11) NOT NULL COMMENT '注册人数',
  `login_num` int(11) NOT NULL DEFAULT '0' COMMENT '登录人数',
  `video_view_num` int(11) NOT NULL DEFAULT '0' COMMENT '每日播放视频数',
  `course_num` int(11) NOT NULL DEFAULT '0' COMMENT '每日新增课程数',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `statistics_day` (`date_calculated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='网站统计日数据';

-- ----------------------------
-- Records of statistics_daily
-- ----------------------------
BEGIN;
INSERT INTO `statistics_daily` VALUES ('1', '2019-08-21', 2, 0, 0, 0, NULL, NULL);
INSERT INTO `statistics_daily` VALUES ('1268356636195835906', '2019-07-16', 3, 112, 184, 174, NULL, NULL);
INSERT INTO `statistics_daily` VALUES ('1268365970476888066', '2019-08-28', 1, 156, 127, 156, NULL, NULL);
INSERT INTO `statistics_daily` VALUES ('1268775793865416705', '2019-08-29', 1, 174, 178, 194, NULL, NULL);
INSERT INTO `statistics_daily` VALUES ('2', '2019-08-22', 10, 0, 0, 0, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ucenter_member
-- ----------------------------
DROP TABLE IF EXISTS `ucenter_member`;
CREATE TABLE `ucenter_member` (
  `id` char(19) NOT NULL COMMENT '会员id',
  `openid` varchar(128) DEFAULT NULL COMMENT '微信openid',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机号',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
  `sex` tinyint(2) unsigned DEFAULT NULL COMMENT '性别 1 女，2 男',
  `age` tinyint(3) unsigned DEFAULT NULL COMMENT '年龄',
  `avatar` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `sign` varchar(100) DEFAULT NULL COMMENT '用户签名',
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用 1（true）已禁用，  0（false）未禁用',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员表';

-- ----------------------------
-- Records of ucenter_member
-- ----------------------------
BEGIN;
INSERT INTO `ucenter_member` VALUES ('1080736474191646722', NULL, '13700000000', '96e79218965eb72c92a549dd5a330112', '用户nVexScJJoi', 1, 20, NULL, NULL, 0, 0, '2019-01-01 12:11:33', '2019-01-12 11:00:22');
INSERT INTO `ucenter_member` VALUES ('1080736474267144193', NULL, '13700000001', '96e79218965eb72c92a549dd5a330112', '用户XJtDfaYeKk', 1, 19, NULL, NULL, 0, 0, '2019-01-02 12:12:45', '2019-01-02 12:12:56');
INSERT INTO `ucenter_member` VALUES ('1080736474355224577', NULL, '13700000002', '96e79218965eb72c92a549dd5a330112', '用户wUrNkzAPrc', 1, 27, NULL, NULL, 0, 0, '2019-01-02 12:13:56', '2019-01-02 12:14:07');
INSERT INTO `ucenter_member` VALUES ('1086387099449442306', NULL, '13520191388', '96e79218965eb72c92a549dd5a330112', '用户XTMUeHDAoj', 2, 20, NULL, NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099520745473', NULL, '13520191389', '96e79218965eb72c92a549dd5a330112', '用户vSdKeDlimn', 1, 21, NULL, NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099608825858', NULL, '13520191381', '96e79218965eb72c92a549dd5a330112', '用户EoyWUVXQoP', 1, 18, NULL, NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099701100545', NULL, '13520191382', '96e79218965eb72c92a549dd5a330112', '用户LcAYbxLNdN', 2, 24, NULL, NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099776598018', NULL, '13520191383', '96e79218965eb72c92a549dd5a330112', '用户dZdjcgltnk', 2, 25, NULL, NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099852095490', NULL, '13520191384', '96e79218965eb72c92a549dd5a330112', '用户wNHGHlxUwX', 2, 23, NULL, NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1106746895272849410', 'o1R-t5u2TfEVeVjO9CPGdHPNw-to', NULL, NULL, '檀梵\'', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/zZfLXcetf2Rpsibq6HbPUWKgWSJHtha9y1XBeaqluPUs6BYicW1FJaVqj7U3ozHd3iaodGKJOvY2PvqYTuCKwpyfQ/132', NULL, 0, 0, '2019-03-16 10:39:57', '2019-03-16 10:39:57');
INSERT INTO `ucenter_member` VALUES ('1106822699956654081', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, '2019-03-16 15:41:10', '2019-03-16 15:41:10');
INSERT INTO `ucenter_member` VALUES ('1106823035660357634', 'o1R-t5i4gENwHYRb5lVFy98Z0bdk', NULL, NULL, 'GaoSir', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJI53RcCuc1no02os6ZrattWGiazlPnicoZQ59zkS7phNdLEWUPDk8fzoxibAnXV1Sbx0trqXEsGhXPw/132', NULL, 0, 0, '2019-03-16 15:42:30', '2019-03-16 15:42:30');
INSERT INTO `ucenter_member` VALUES ('1106823041599492098', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, '2019-03-16 15:42:32', '2019-03-16 15:42:32');
INSERT INTO `ucenter_member` VALUES ('1106823115788341250', 'o1R-t5l_3rnbZbn4jWwFdy6Gk6cg', NULL, NULL, '换个网名哇、', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/jJHyeM0EN2jhB70LntI3k8fEKe7W6CwykrKMgDJM4VZqCpcxibVibX397p0vmbKURGkLS4jxjGB0GpZfxCicgt07w/132', NULL, 0, 0, '2019-03-16 15:42:49', '2019-03-16 15:42:49');
INSERT INTO `ucenter_member` VALUES ('1106826046730227714', 'o1R-t5gyxumyBqt0CWcnh0S6Ya1g', NULL, NULL, '我是Helen', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKDRfib8wy7A2ltERKh4VygxdjVC1x5OaOb1t9hot4JNt5agwaVLdJLcD9vJCNcxkvQnlvLYIPfrZw/132', NULL, 0, 0, '2019-03-16 15:54:28', '2019-03-16 15:54:28');
INSERT INTO `ucenter_member` VALUES ('1106828185829490690', 'o1R-t5nNlou5lRwBVgGNJFm4rbc4', NULL, NULL, ' 虎头', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKxCqRzuYWQmpwiaqQEjNxbC7WicebicXQusU306jgmfoOzUcFg1qaDq5BStiblwBjw5dUOblQ2gUicQOQ/132', NULL, 0, 0, '2019-03-16 16:02:58', '2019-03-16 16:02:58');
INSERT INTO `ucenter_member` VALUES ('1106830599651442689', 'o1R-t5hZHQB1cbX7HZJsiM727_SA', NULL, NULL, '是吴啊', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJ9CsqApybcs7f3Dyib9IxIh0sBqJb7LicbjU4WticJFF0PVwFvHgtbFdBwfmk3H2t3NyqmEmVx17tRA/132', NULL, 0, 0, '2019-07-16 16:12:34', '2019-03-16 16:12:34');
INSERT INTO `ucenter_member` VALUES ('1106830976199278593', 'o1R-t5meKOoyEJ3-IhWRCBKFcvzU', NULL, NULL, '我才是Helen', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83epMicP9UT6mVjYWdno0OJZkOXiajG0sllJTbGJ9DYiceej2XvbDSGCK8LCF7jv1PuG2uoYlePWic9XO8A/132', NULL, 0, 0, '2019-07-16 16:14:03', '2019-03-16 16:14:03');
INSERT INTO `ucenter_member` VALUES ('1106831936900415490', 'o1R-t5jXYSWakGtnUBnKbfVT5Iok', NULL, NULL, '文若姬', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/3HEmJwpSzguqqAyzmBwqT6aicIanswZibEOicQInQJI3ZY1qmu59icJC6N7SahKqWYv24GvX5KH2fibwt0mPWcTJ3fg/132', NULL, 0, 0, '2019-07-16 16:17:52', '2019-03-16 16:17:52');
INSERT INTO `ucenter_member` VALUES ('1106832491064442882', 'o1R-t5sud081Qsa2Vb2xSKgGnf_g', NULL, NULL, 'Peanut', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-08-28 16:20:04', '2019-03-16 16:20:04');
INSERT INTO `ucenter_member` VALUES ('1106833021442510849', 'o1R-t5lsGc3I8P5bDpHj7m_AIRvQ', NULL, NULL, '食物链终结者', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/MQ7qUmCprK9am16M1Ia1Cs3RK0qiarRrl9y8gsssBjIZeS2GwKSrnq7ZYhmrzuzDwBxSMMAofrXeLic9IBlW4M3Q/132', NULL, 0, 0, '2019-08-29 16:22:11', '2019-03-16 16:22:11');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
